CREATE PROC USP_LAY_DANH_SACH_Menu
AS
BEGIN
	SELECT *
	FROM Menu
END

execute USP_LAY_DANH_SACH_Menu







USE [MyHotel]
GO
/****** Object:  StoredProcedure [dbo].[SP_THEMNHANVIEN]    Script Date: 01/11/2013 14:31:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Create proc [dbo].[SP_THEMCHUCVU] @TenChucVu NVARCHAR(50) as
BEGIN
	insert into ChucVu(TenChucVu) values(@TenChucVu)
END